51 Excel practical work
Excel practical work work data organization, function,,, automation, collaboration up to field type productivity education with.
0. Purpose and ultimate goal
Excel practical work education of objective learners Microsoft Excel 365 focused with table writing, function, pivot table, Power Query,, VBA/Office Scripts basic using work analysis · Deliverables. · · · of Excel · data analysis course using practical work file completion and work application focused with operation.
Referenced professional training patterns
- Excel course of function, table management, pivot table, chart report
- Excel course of advanced function, Power Query,, automation focused
- Data analysis type Excel course of data organization,, visualization, collaboration practice
- Company type Excel education of 1~2 course and 4~8 weeks practical work project type course
Beginner · 1 Day
Beginner 1 day Excel practical work curriculum
Work table writing, basic function, sorting · filter, up to practical work with.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Work table writing. | Excel Table,, · ·, application using practical work table create. And data with entry table entry create. |
| Objective 2 | Basic function and. | SUM, AVERAGE, COUNT, COUNTIF, IF, IFERROR, ROUND sales · · with practice. Sorting, filter, subtotal, analysis tools using by and perform. |
| Objective 3 | File complete. | , /,,, PDF saving settings application. Work report file · · management rules application. |
| Platforms | Microsoft Excel 365, Excel Web, Google Sheets comparison, PDF saving, OneDrive or Google Drive |
|---|---|
| Instructor profile | Excel basic · OA practical work · document writing education 2years or more |
| Target learners | Introductory, job seeker, small business owner,, |
| Duration | 4-6 hours |
| Materials | , Excel 365 or Excel 2021, sales// data, mouse |
| Deliverables | Work table, basic function table, file, report |
| Assessment method | Table writing 25%, function use 30%, data organization 20%, report completion 15%, participation 10% |
Beginner · 3 Days
Beginner 3 days Excel practical work curriculum
Function, table management, chart, pivot table basic through practical work report create.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Work function and function application. | IF, IFS, SUMIFS, COUNTIFS, XLOOKUP, VLOOKUP, TEXT, DATE function · sales · education operation data to application. And,, practice file to. |
| Objective 2 | Pivot table and chart with. | Excel Table based data pivot table with connect by · local community by · by table create. Chart, chart, chart, chart to creation. |
| Objective 3 | Collaboration report file create. | Protection, entry · ·, data rules application. OneDrive or Google Drive in sharing and management method practice. |
| Platforms | Microsoft Excel 365, PivotTable, Excel Chart, OneDrive, Google Sheets comparison, Microsoft Forms |
|---|---|
| Instructor profile | Excel function · pivot table · chart report · collaboration file education 3years or more |
| Target learners | ,, educationorganization practitioner, /marketing, job seeker |
| Duration | 12-18 hours |
| Materials | , Excel 365, work data 3, Microsoft or Google account |
| Deliverables | Function practice file, table, chart report, collaboration work |
| Assessment method | Function 30%, 25%, chart 20%, file 15%, presentation 10% |
Beginner · 1 Week
Beginner 1 week Excel practical work curriculum
Data organization, analysis function,, basic practical work type course.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Excel data organization. | ,, Flash Fill, data, work data to application. Power Query basic with CSV,,, null, with practice. |
| Objective 2 | Analysis function and. | XLOOKUP, FILTER, UNIQUE, SORT, SUMIFS, COUNTIFS, LET basic using analysistable create. Pivot table,, using · · local community by create. |
| Objective 3 | Creation. | KPI, by, by comparison, by to. Chart, rules,, /sharing settings application using complete. |
| Platforms | Excel 365, Power Query, PivotTable, Slicer, Timeline, Dynamic Array Functions, OneDrive, Teams |
|---|---|
| Instructor profile | Excel data analysis · Power Query basic · creation education 3years or more |
| Target learners | Practitioner, /marketing/education operation, data analysis introductory, job seeker |
| Duration | 20-30 hours |
| Materials | , Excel 365, CSV, work report, file |
| Deliverables | Data, analysis function file,, practical work |
| Assessment method | Data organization 25%, analysis function 25%, 20%, 20%, presentation 10% |
Intermediate · 4 Weeks
Intermediate 4 weeks Excel practical work curriculum
Power Query, advanced function,, automation basic using work improvement.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Data automation. | Power Query with file, table,, data procedure. Data also with with report file create. |
| Objective 2 | Advanced function and application. | XLOOKUP, INDEX/MATCH, FILTER, UNIQUE, LET, LAMBDA basic, SUMPRODUCT work to application. Power Pivot basic and relationship type data using analysis create. |
| Objective 3 | Management creation. | KPI,, comparison,, design. Chart,,, data using create. |
| Platforms | Excel 365, Power Query, Power Pivot basic, PivotChart, Dynamic Arrays, OneDrive, Power BI |
|---|---|
| Instructor profile | Excel advanced function · Power Query · · automation education 4years or more |
| Target learners | Intermediate, team practitioner, data analysis introductory, education operation management, / |
| Duration | 40-60 hours |
| Materials | , Excel 365, file, by CSV, KPI, work report |
| Deliverables | Power Query automation file, advanced function analysistable, management, automation manual |
| Assessment method | Automation 30%, advanced function 25%, data 15%, 20%, presentation 10% |
Advanced · 8 Weeks
Advanced 8 weeks Excel practical work curriculum
Excel based data analysis, VBA/Office Scripts basic, education practice system complete.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Excel analysis project perform. | Sales, education,,, of practical work data using problem and analysis plan writing. Power Query, Power Pivot, advanced function, using --analysis-. |
| Objective 2 | Automation. | VBA basic or Office Scripts with, application, file saving, report automation. Power Automate using Forms, Excel, email design. |
| Objective 3 | Excel practical work education content develop. | Beginner · intermediate · advanced learners by practice data, assignment, file, assessment rubric creation. Company/organization type Excel practical work course,,, assessmenttable writing. |
| Platforms | Excel 365, Power Query, Power Pivot, VBA basic, Office Scripts, Power Automate, Power BI, OneDrive, Teams |
|---|---|
| Instructor profile | Excel analysis project · VBA/Office Scripts · Power Query · company education design 5years or more |
| Target learners | Excel instructor course, data practitioner, team, automation, company education |
| Duration | 80-120 hours |
| Materials | , Excel 365, data, VBA, education design, presentation materials tools |
| Deliverables | Excel analysis project file, automation,, curriculum, assessment rubric |
| Assessment method | Analysis project 30%, automation 25%, 20%, educationmaterials 15%, presentation 10% |